#导入蓝图模块
from flask import Blueprint,request
from flask.json import jsonify

from dbb import db1
import json

from utils.myfile import myfile
# #实例化
bp_course = Blueprint("course",__name__)

# #接口
# @bp_course.route('/couponM',methods=['POST',"GET",'PUT','DELETE'])
# def couponM():
#     #添加
#     if request.method == "POST":
#         #获取用户输入
#         data = request.data
#         if data:
#             data = json.loads(data)
#         else:
#             data = request.form
#         #构造sql语句
#         sql = "insert into coupon values(0,'%s',%d,'%s','%s')"%(data['name'],int(data['total']),data['stime'],data['etime'])
#         #pymysql
#         db1.insert(sql)
#         #返回结果
#         return 'ok'
#     elif  request.method == "PUT":
#         #修改
#         #获取用户输入
#         data = request.data
#         if data:
#             data = json.loads(data)
#         else:
#             data = request.form
#         #构造sql语句 update 表名 set 字段名1=值，字段名2=值 where id=1
#         sql = "update coupon set name='%s',total=%d,starttime='%s',endtime='%s' where id=%d"%(data['name'],int(data['total']),data['stime'],data['etime'],int(data['id']))
#         db1.insert(sql)
#         return jsonify({"code":200})
#     elif request.method=="DELETE":
#         #获取 id
#         id=request.args.get('id')
#         sql="delete from coupon where id=%d"%(int(id))
#         db1.insert(sql)
#         return jsonify({"code":200})
#     else:
#         id=request.args.get('id')
#         sql="select * from coupon where id=%d"%(int(id))
#         res=db1.find(sql)
#         return jsonify({"code":200,'coupon':res})
    

import os    
#文件上传
@bp_course.route('/upload',methods=['POST'])
def upload():
    #获取文件
    file = request.files['file']
    #选择文件夹
    #创建文件夹
    myfile.file_mkdir(2)
    #保存文件
    file.save(os.path.join('./static/upload/2/',file.filename))
    #保存 /static/upload/1/
    return 'ok'
@bp_course.route('/citym')
def citym():
    sql="select id,name from city"
    res=db1.findall(sql)
    return jsonify({"code":200,'list':res})

# @bp_course.route('/prom',methods=['POST'])
# def prom():
#    data = get_data()
#    sql = "insert into product(title,price,city_id,pic) values('%s',%.2f,%d,'%s')"%(data['title'],float(data['price']),int(data['city_id']),data['pic'])
#    db1.insert(sql)
#    return jsonify({"code":200})

    # else:
    #     #根据分类id查询分类下商品
    #     cityid = request.args.get('cityid')
    #     if  cityid == '0':
    #         sql = "select * from product"
    #     else:
    #         sql = "select * from product where city_id=%d"%(int(cityid))
    #     res = db1.findall(sql)
    #     return jsonify({"code":200,'list':res})
    
    #获取订单接口
@bp_course.route('/orderM')
def orderM():
    sql = 'select * from orders'
    res = db1.findall(sql)
    return jsonify({"code":200,'list':res})
#获取分类接口
@bp_course.route('/orderM',methods=['GET','PUT'])
def orderM():
    if request.method == "PUT":
        id = request.args.get('id')
        sql = "select * from orders where id=%d"%(int(id))
        res = db1.find(sql)
        #判断状态原来为1改成2，原来为2改成1
        status = 2
        if int(res['status']) == 2:
            status=1            
        
        #执行更新操作
        sql1 = "update orders set status=%d where id=%d"%(status,int(id))
        db1.insert(sql1)
        return jsonify({"code":200})

    else:
        #当前页
        page = int(request.args.get('page'))
        #每页显示多少条
        page_size = int(request.args.get('page_size'))
        start = (page-1)*page_size
        sql = 'select * from orders limit %d,%d'%(start,page_size)
        res = db1.findall(sql)
        #总条数
        sql1 = "select count(id) from orders"
        res1 = db1.find(sql1)
        return jsonify({"code":200,'list':res,'total':res1['count(id)']})

